Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
WorkerID (PK) | A unique system-assigned identifier for the Person who is a particular Worker. | ID_WRKR | Identity | integer | |
WorkerTypeCode | A unique retailer assigned code denoting the kind of Worker. | TY_WRKR | Code2 | char(2) | |
WorkerPhotograph | A binary data object containing a current photographic image of the Worker. | BM_PGPH_WRKR | Image | varbinary | |
SpecialRequirements | A narrative describing any special requirements the Worker has when working. e.g. Wheelchair access required. | DE_SPL_RQMT | DescriptionNarrative | varchar(4000) | |
PartyRoleAssignmentID (FK) | Token identifier for a PartyRoleAssignmentInstance. | ID_PRTY_RO_ASGMT | Identity | integer | PartyRoleAssignment(PA_RO_PRTY) |